Tabela LSysFctResourceItem

Definicja tabeli LSysFctResourceItem

Name

LSysFctResourceItem

Code

LSysFctResourceItem

Comment

Zadanie tabeli to przechowywanie inf. o powiazaniach rodzajów zamówien (wydruk
SysFctID) z zasobami (ResourceID)


Lista kolumn tabeli LSysFctResourceItem

Name

Code

LSysFctResourceItemID

LSysFctResourceItemID

ResourceID

ResourceID

SysFctID

SysFctID

FunctionID

FunctionID

StartDT

StartDT

StopDT

StopDT


Kolumna LSysFctResourceItemID tabeli LSysFctResourceItem

Definicja kolumny LSysFctResourceItemID tabeli LSysFctResourceItem

Name

LSysFctResourceItemID

Code

LSysFctResourceItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PK


Kolumna ResourceID tabeli LSysFctResourceItem

Definicja kolumny ResourceID tabeli LSysFctResourceItem

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

FK (tabela ResourceItem)


Kolumna SysFctID tabeli LSysFctResourceItem

Definicja kolumny SysFctID tabeli LSysFctResourceItem

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

No

Comment

FK (tabela SysFct)


Kolumna FunctionID tabeli LSysFctResourceItem

Definicja kolumny FunctionID tabeli LSysFctResourceItem

Name

FunctionID

Code

FunctionID

Data Type

NUMBER(10)

Mandatory

No

Comment

FK (tabela SysFctID)


Kolumna StartDT tabeli LSysFctResourceItem

Definicja kolumny StartDT tabeli LSysFctResourceItem

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli LSysFctResourceItem

Definicja kolumny StopDT tabeli LSysFctResourceItem

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli LSysFctResourceItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LSysFctResourceItem

Definicja klucza Identifier_1 tabeli LSysFctResourceItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment